A Multidimensional Database to Help Anticipate on Truck Arrival Time

Each distribution center has a different solution to prepare itself for incoming trucks. Due to different circumstances trucks can arrive earlier or later than anticipated. It is very hard, or maybe even impossible, for distribution centers to predict the actual truck arrival times, when they don’t know anything about the schedules from incoming trucks. A solution for these distribution centers is a multidimensional database. This database gives information about the performances of the different haulers in different circumstances. This information can be used to predict a more exact arrival time of the incoming trucks, so the average time of the cargo in the holding area can be decreased and money will be saved. In this case study a schematic of a multidimensional database will be designed for a Dutch distribution center that doesn’t share any information with their haulers. During this case study a literature study, survey and interview will be done and business processes will be studied to determine relevant data to put in the multidimensional database. The scheme of the dimensional database is applicable for all distribution centers which don’t have information about the incoming trucks and want a way to predict the arrival times of their incoming trucks more accurate.